Monthly Activity

The Monthly Activity report ages the AR and WIP beginning and ending balances, providing an overview of billable account activity.

Note: This report should complete well within two hours of run time. If the report takes longer than that to complete, the report should be closed and rerun with additional filter criteria to narrow down results.

Permissions Required for this Report

In the staff profile, staff must be assigned to a security group that is granted View functional rights for the following:

  • Security group profile > Functional rights > Reports > Shared Library > Shared Views
  • Security group profile > Functional rights > Reports > Firm Library > Custom
  • Security group profile > Functional rights > Reports > Firm Library > Standard > Firm
  • Security group profile > Functional rights > Reports > Firm Library > Standard > Practice
  • Security group profile > Functional rights > Reports > Firm Library > <report name>

Reports in Foundation that are Comparable

In Practice Management, the comparable report is Monthly Activity (Custom Library). In Practice Advantage, there is no comparable report.

Report Specifications

The following report options and filters are available to determine the report contents.

Options and Settings    
Option Setting Description

Set Number of Days for Aging Period 1

Numeric

Includes the number of days specified for aging period 1. Enter 0 to exclude this aging period.

Set Number of Days for Aging Period 2

Numeric

Includes the number of days specified for aging period 2. Enter 0 to exclude this aging period.

Set Number of Days for Aging Period 3

Numeric

Includes the number of days specified for aging period 3. Enter 0 to exclude this aging period.

Set Number of Days for Aging Period 4

Numeric

Includes the number of days specified for aging period 4. Enter 0 to exclude this aging period.

Set Number of Days for Aging Period 5

Numeric

Includes the number of days specified for aging period 5. Enter 0 to exclude this aging period.

Set Number of Days for Aging Period 6

Numeric

Includes the number of days specified for aging period 6. Enter 0 to exclude this aging period.

Set Number of Days for Aging Period 7

Numeric

Includes the number of days specified for aging period 7. Enter 0 to exclude this aging period.

Select to Age Transactions Using…

List

Determines whether the transaction date or accounting period date is used to determine aging.

Hide Comma

Yes/No

Includes or excludes commas in numbers.

Hide Penny

Yes/No

Includes or excludes cents in amounts.

Include Deleted Clients

Yes/No

Includes or excludes deleted client information
Default Filters
Field Name Operator Value
Transaction Date Between

First Day of Current Fiscal Year; Last Day of Current Fiscal Year
Optional Filters
Available Fields

Accounting Period Date

Client ID

Client Sub ID

Business Code

Client ID.Sub ID

Client Type

Client

Client Name

Current

Client – Principal

Client Office

Financial Reporting Client Group

Client Bill Manager

Client Primary Service Type

Line of Business

Client Business Unit

Client Region

Manager

Posted Date

Return Group

Transaction Date

Primary Partner

Tax Type

 

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Grouping    
Available Fields

Business Code

Client Name

Line of Business

Client

Client Office

Manager

Client - Principal

Client Primary Service Type

Primary Partner

Client Bill Manager

Client Region

Return Group

Client Business Unit

Client Sub ID

Sort Name

Client ID

Client Type

Tax Type

Client ID.Sub ID

Financial Reporting Client Group

 

Note: The Manager and Primary Partner field names are the default values defined for client responsible staff. The first ten client responsible staff List values that are defined by your firm are available field options.

Sorting
There are no sorting options for this report.

Report Fields

The following fields are available for this report. The fields that display and the position of fields are based on the report's settings, grouping, sorting, and filters.

Report Fields
Field Description

Client

The client name and client ID.

Accounts Receivable <start date of the report>

The net total of all receivable amounts as of the start date of the report.

Invoices

The total invoice amount (billed WIP +/- write up/down + sales tax) posted during the range selected.

Payments

The net total of all payments received and posted during the date range selected, regardless of the distribution status.

Adjustments

The net total of all debit and credit adjustments.

Write-Offs

 The total of all AR write-offs for the date range selected.

Misc Debit

The miscellaneous charges, handling fees, and finance charges that are entered in AR.

Credit Memos

The total of all posted credit memos for the date range selected.

Debit Memos

The total of all posted debit memos for the date range selected.

A/R Balance <ending date of the report>

The sum of beginning AR + invoices - payments +/- adjustments - write-offs + misc debit - credit memos + debit memos +/- corrections +/- voids.

Work in Progress <start date of the report>

All open, posted, and billable WIP, including on hold and expenses as of the start date of the report.

Time

All open, posted, and billable time entered for the date range select.

Expenses

All posted, billable expenses entered during the date range selected.

WIP Available

The sum of beginning WIP + billable time + billable expenses +/- transfers +/- corrections.

Billed Amounts

The total WIP on posted invoices for the date range selected.

Write Downs

The total write downs for the date range selected, including WIP write-offs.

Write Ups

The total write ups for the date range selected.

WIP Relieved

The billed amounts - write up + write downs. This will be displayed as a negative number.

Progress Bills

The net of progress billed and progress applied for the period selected.

Balance of WIP <ending date of the report>

The WIP available - WIP relieved +/- progress bills.

Beginning AR Percentages

The percentage of total beginning AR by aging interval.

Ending AR Percentages

The percentage of total ending AR by aging interval.

Beginning WIP Percentages

The percentage of total beginning WIP by aging interval.

Ending WIP Percentages

The percentage of total ending WIP by aging interval.

Monthly Activity Sample Report